You can use SQL JOIN statements to combine data from three or more tables. In an earlier article, we took a look at using inner joins and outer joins to combine data from two different tables. In many cases, you’ll want to take this a step further and combine data from three or more tables. In Joining Multiple Tables with SQL Inner Join Statements, we look at the SQL statements that allow you to accomplish this goal for an inner join.

Read the full article: Joining Multiple Tables with SQL Inner Join Statements

It’s often necessary to convert data stored in an Access database to another form, such as an Excel workbook. You may wish to take advantage of some of Excel’s unique analytical capabilities or simply share data with someone unfamiliar with Access. Whatever the reason, the conversion process is fairly straightforward and quick.

Read the full article: Export Data from Microsoft Access 2007 to Microsoft Excel

In a recent forum message, Russ wrote:

"I have been a professional Wrestling fan for many years and over that time collected thousands and thousands of wrestling matches which I'm in the process of converting to DVD. I have always kept a good record of my collection starting with pen and paper lists and in the last few years using tables in Microsoft Word.

I would now like to set up a database where I can locate and sort through the matches a little better than my current system. Basically, I would like something that sorts the wrestler, their opponent, their partner (if appropriate) and the date of the match. Other things on the database that I would like but are not crucial are the company, aliases/names, managers, events, and probably a few other things that I can't think of right now.

Can anyone please help me out with this one or does anyone know of someone who has already created their own wrestling database? I do not need the data base to be available over the Internet."

Can you help Russ? Interested in solutions to the same problem? Join the discussion in our forum!

Backing up your Microsoft Access databases is an important part of protecting your critical data. In this tutorial, we walk through the process of backing up an Access database, step-by-step.

Read the full article: How to Back Up a Microsoft Access Database.